package com.bingo.mpa.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import org.express.portal.PathUtil;


public class ConnectionPool
{
	public static Connection getConnection()  
    {
		final String driver = PathUtil.getString("dbDriver");
        final String url = PathUtil.getString("dbUrl");
        final String usr = PathUtil.getString("dbUser");
        final String pwd = PathUtil.getString("dbPassword");
        try  
        {  
            Class.forName(driver);  
            return DriverManager.getConnection(url, usr, pwd);  
        }  
        catch (final ClassNotFoundException e)  
        {  
            e.printStackTrace();
        }  
        catch (final SQLException e)  
        {  
            e.printStackTrace();
        }  
        return null;  
    }
}
